SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlLiquidacionBYP
AS
SELECT dbo.tb_LiquidacionBYP.idLiquidacionByP AS Id, dbo.tb_LiquidacionBYP.Descripcion AS Liquidacion, dbo.vwrLineasDeBYP.Descripcion AS Linea, 
               dbo.tb_LiquidacionBYP.Año, dbo.tb_LiquidacionBYP.NumeroPeriodo, dbo.tb_LiquidacionBYP.Pagado
FROM  dbo.tb_LiquidacionBYP INNER JOIN
               dbo.vwrLineasDeBYP ON dbo.tb_LiquidacionBYP.IdLineaDeByP = dbo.vwrLineasDeBYP.Id
GO
GRANT SELECT ON  [dbo].[vwlLiquidacionBYP] TO [Becas]
GRANT SELECT ON  [dbo].[vwlLiquidacionBYP] TO [SoloVer]
GO
